<?php
include 'connectDB.php';
// Combien d'entr�es dans jeux_vid�o ?
$retour = mysql_query("SELECT COUNT(*) AS nbre_entrees FROM film") or die(mysql_error()); // Requ�te SQL
$donnees = mysql_fetch_array($retour);

mysql_close(); // D�connexion de MySQL
?>

<?php
		mysql_connect("127.0.0.1", "root", "");
		mysql_select_db("hulinfouco");

// Combien d'entr�es dans jeux_vid�o ?
$nombre_visiteur = mysql_query("SELECT COUNT(*) AS nbre_client FROM client") or die(mysql_error()); // Requ�te SQL
$visiteur = mysql_fetch_array($nombre_visiteur);

mysql_close(); // D�connexion de MySQL
?>

<?php
		mysql_connect("127.0.0.1", "root", "");
		mysql_select_db("hulinfouco");

$retour = mysql_query("SELECT COUNT(*) AS nb_commande FROM commande WHERE etat='Finaliser' OR etat='Annuler'");
$commandeV = mysql_fetch_array($retour);

mysql_close(); // D�connexion de MySQL
?>

<?php
		mysql_connect("127.0.0.1", "root", "");
		mysql_select_db("hulinfouco");

$retour = mysql_query("SELECT COUNT(*) AS nb_commande FROM commande WHERE etat='En Cours' OR etat='En R�approvisionnement'");
$commandeC = mysql_fetch_array($retour);

mysql_close(); // D�connexion de MySQL
?>

<ul>
	<strong style="color:#8f9d4c;"><center>NAVIGATION</center></strong>
	<li><a href="index.php?page=accueil">Accueil</a></li>
	<li><a href="index.php?page=nouveaute">Nouveaut�</a></li>
	<li><a href="index.php?pagefilm=1">Liste des films (<?php echo $donnees['nbre_entrees']; ?>)</a></li>
	<li><a href="index.php?page=cinema">Cin&eacute;ma</a></li>
	<li><a href="index.php?page=contact">Contactez nous</a></li>
	<br /><br /><br /><strong style="color:#f47b33;"><center>ADMINISTRATION</center></strong>
	<li><a href="index.php?page=client">Liste des clients (<?php echo $visiteur['nbre_client']; ?>)</a></li>
	<li><a href="index.php?page=ajouter_film">Ajouter film</a></li>
	<li><a href="index.php?page=supprimer_film">Supprimer film</a></li>
	<li><a href="index.php?page=gestion_commande">Commandes en cours (<?php echo $commandeC['nb_commande']; ?>)</a></li>
	<li><a href="index.php?page=gestion_commande_valide">Commandes finalis&eacute;es (<?php echo $commandeV['nb_commande']; ?>)</a></li>
</ul>





